Release 10.1A: OpenEdge Data Management:
SQL Development

An overview of OpenEdge SQL

OpenEdge offers essential flexibility in developing software solutions by providing a high performance relational database and an open, standards-based interface for SQL. The OpenEdge database and its SQL interface provide an environment that enables efficient integration with third-party tools, such as development software, reporting, and Online Analytical Processing (OLAP) tools.

Featuring a state-of-the-art, cost-based query optimizer, the OpenEdge SQL Engine incorporates APIs for ODBC and JDBC.

OpenEdge SQL consists of the following components:

OpenEdge SQL Engine — The OpenEdge SQL Engine is installed as part of the OpenEdge Relational Database Management System. To support the OpenEdge Service Oriented Architecture, the SQL engine offers robust data type support, enables online schema changes, and provides for query optimization. These features are designed to maximize database scalability and performance.
JDBC Driver for OpenEdge by DataDirect — The JDBC Driver for OpenEdge is a third-party product provided by DataDirect Technologies. The JDBC driver enables Java-based applications to access the OpenEdge RDBMS. The JDBC driver is installed as part of the OpenEdge SQL Client Access product.
ODBC Driver for OpenEdge by DataDirect — The ODBC Driver for OpenEdge is a third-party product provided by DataDirect Technologies. The ODBC driver provides access to the OpenEdge database from applications that support the ODBC interface. The ODBC driver is installed as part of the OpenEdge SQL Client Access product.